in the General tab, i see the "Total Items" for each user mailbox - is there a way to get this dumped out to txt for the entire store?~if this were /. this sig would be funny

You should be able to do this from the EMS with the following: Get-MailboxDatabase "your_database_name" | Get-MailboxStatistics | ft displayname, itemcount >C:\file_name.txt -Matt

get-mailbox | get-mailboxstatistics |fl displayname, itemcount >c:\export.txt James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com

clean and simple, thanks!~if this were /. this sig would be funny

also works, and more "human friendly" but i prefer the single line approach of Matt B so i can bring it into Excel. thanks guys!~if this were /. this sig would be funny

On Thu, 6 Sep 2012 15:33:30 +0000, can_i_bum_a_sig wrote: >also works, and more "human friendly" but i prefer the single line approach of Matt B so i can bring it into Excel. "One-liners" aren't always the best thing to use. If "displayname" has a comma in it (e.g. "Smith, John") you'll have a problem. Something like this is longer, but gets you a real CSV file with delimeter protection: $List = @() Get-MailboxDatabase "your_database_name" | Get-MailboxStatistics | foreach { $x = ""|select DisplayName,Itemcount $x.DisplayName = $_.DisplayName $x.Itemcount = $_.ItemCount $list += $x } $list | export-csv <filename> -notypeinfo You can expand upon that to get information from other cmdlets into the CSV, too. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

I do agree with Rich about one-liners, and there limitations, but to defend the one-liners (and fellow slackers like myself :)) ...you can still do this same query in a one-liner, if having a CSV output is what your after: # Get-MailboxDatabase "your_database_name" | Get-MailboxStatistics | select displayname, itemcount | export-csv c:\file_name.csv -NoTypeInformation -Matt

In addition, you can also try the following cmdlet. Hope it is useful. Get-MailboxStatistics -Database Mailbox Database | Select DisplayName, ItemCount | Export-Csv C:\Filename.csvNoya Lau TechNet Community Support